When running the SAS Merchandise Data Integration mdi_loadfact.sas job, the post-fact load process might experience long run times due to the overhead of a parallel query execution. This issue might occur because SAS Merchandise Data Integration reports each time the partition of a fact table has data or no data. The first rownum for each time segment of a fact table is queried, resulting in the long run time.

On occasion, the Oracle Query Optimizer chooses a parallel execution path even if only a single record is queried. Due to this overhead, the query, which otherwise would run faster, takes a longer amount of time.

The workaround involves overwriting the parallel query execution path of the Oracle optimizer. A NOPARALLEL query hint should be applied for all queries that fetch only the first rownum from all time segments of the fact tables.

Contact Technical Support for more regarding the workaround for this issue.

Operating System and Release Information